from sqlalchemy import create_engine, text

engine = create_engine("mysql+pymysql://root:testroot@192.168.43.206:3306/sqlalchemy_test", echo=True)

with engine.connect() as conn:
    conn.execute(text("create table some_table (x int, y int)"))
    conn.execute(text("insert into some_table (x, y) values (:x, :y)"), [{"x": 1, "y": 1}, {"x": 2, "y": 4}])
    conn.commit()

